EMT Practice Test

1. Question Content...

---

Question1: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question2: The default path for all supporting files, data sources, icons, logs etc is in ______________________

Question3: Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Question4: True or False : Bins can be created on dimensions

Question5: If you see the following Filter, then you're working with _______________________ Larger image

Question6: __________ is a technique in Tableau which will identify marks with similar characteristics

Question7: Which of the following is not a Trend Line Model?

Question8: Which of the following describes the best way to change the formatting at a workbook level?

Question9:

Question10: Dates in Tableau are typically treated as ______________

Question11: True or False: The Highlighting action can be disabled for the entire workbook.

Question12: Which of the following points are True about Viz Animations?

Question13: Which of the following is a good reason for using a bullet graph?

Question14: DOWNLOAD THE DATASET FROM - https://drive.google.com/file/d/1F8L_Rl5B9LAz8RDi-DdjWx3Iv-SgzaBq/view?usp=sharing ( if you haven't already from the test instructions page! ) How many different countries are present in the dataset?

Question15: Which of the following lets you group related dashboard items together so you can quickly position them?

Question16: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question17: To customize links based on the data in your dashboard, you can automatically enter field values as _______________ in URLs

Question18: __________ is a technique in Tableau which will identify marks with similar characteristics

Question19: ______________ refers to the level of detail for a piece of data, wherever you are looking.

Question20: Using the Geo Data Table, create a Map showing Sales made per State. For the State of New York (NY), what was the amount in Sales ($) made for Phone Assortments with White color?

Question21: When using Animations in a Tableau, which of the following is the default duration for animations?

Question22: Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Question23: When you want to first apply a filter and THEN show the Top N or Bottom N elements, which of the following filters would you use?

Question24: Which of the following can you use to create a Histogram?

Question25: If you decide you want to see all of the marks in the view at the most detailed level of granularity, you can __________________ the view.

Question26: The row and column shelves contain ___________________

Question27: If you have a dashboard and are displaying its filter, how can you rearrange it?

Question28: If you use a percent difference Quick Table Calculation, what value will be the first data value?

Question29: Using the Geo Data table, create a Bar chart showing the In-Stock percentage for each Color. What is the Average In-Stock percentage for the Color Red? Present your answer correctly upto 2 decimal places.

Question30: When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Question31: What is the minimum amount of RAM recommended for any production use of Tableau Server?

Question32: What is the one most important thing you should do after creating a Dual-axis chart?

Question33: ________________ is hosted by Tableau to share our visualisations publically with the world.

Question34: ________________ is hosted by Tableau to share our visualisations publically with the world.

Question35: Which one of the following is a dimension?

Question36: What will the following function return?
LEFT("Tableau", 3)

Question37: Which of the following are valid ways to copy a worksheet visualisation as an image?

Question38: Create a Set containing Customer Names whose Sales are GREATER than 30,000. Which customer had the LEAST sales in this set?

Question39: The icon associated with the field that has been grouped is a ______________

Question40: True or False: Sets can be created on Measures

Question41: True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Question42: Which of the following is a compelling reason to export a sheet in Tableau to a PDF?

Question43: True or False: All rows from both tables are returned in an INNER JOIN

Question44: How can you add color to marks in the view in Tableau?

Question45: True or False: Sets can be created on Measures

Question46: Which of the following are valid ways of Grouping Data?

Question47: _______________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server.

Question48: According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

Question49: Which of the following are valid use-cases for the 'Manage Metadata' functionality?

Question50: Skipped Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?
Join the Geo Data and Time Series Table on the Item Number ID column, and display the Store count for every State on a Map. What was the Store count in 2017 for Texas (TX)?

Question51: What is the minimum amount of RAM recommended for any production use of Tableau Server?

Question52: What term is used to describe the following picture?

Question53: How would you calculate GDP per capita in Tableau?

Question54: How does Tableau know at which level to aggregate values?

Question55: ________________ files are shortcuts for quickly connecting to the original data that you use often. Data source files do not contain the actual data but rather the information necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.

Question56: What is a story point in Tableau?

Question57: Which of the following are valid ways to copy a worksheet visualisation as an image?

Question58: Is it possible to make a Measure discrete?

Question59: What is a story point in Tableau?

Question60: Using the Time Series Table, create a Line chart showing the Monthly Year over Year Growth for the Sales, broken down by Assortment. For the Electronics assortment, which Month had the most NEGATIVE value of Year over Year Growth?

Question61: ________________ can only create header. _______________ will create header and axis both.

Question62: Our use case states that we need to create a set showing the Bottom 10 products by Profit in each Region. Which of the following filter types should you apply on Region?

Question63: How can you add color to marks in the view in Tableau?

Question64: True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

Question65: _____________ contains the visualisations, info needed to build the visualisations, and a copy of the data source.

Question66: Using the CoffeeChain table, create a Dual Axis chart showing the Sales (Bar chart) and Profit (Line Chart) for each Product type. What was the Profit for the Herbal Tea product type in 2013?

Question67: You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Question68: A field that shows average home values for the United States in 2016 is most likely :

Question69: By default, measures placed in a view are aggregated. The type of aggregation applied ______________

Question70: Using the Time Series table, create a chart that shows the percent difference in Average Inventory on Hand for each Assortment by year and quarter.
How many quarters did the Electronics Assortment show a negative percent difference in the Average Inventory On Hand?

Question71: What does the following marker/icon do in Tableau?

Question72: Which of the following are benefits of using Data Extracts in Tableau?

Question73: True or False: To concatenate fields, they must be of same data type

Question74: You clicked Sheet 1 from the data source page, and now you have opened the Tableau Desktop workspace as shown above. What is the main thing that you do here?

Question75: Which of the following are interactive elements that can be added to a dashboard for users?

Question76: You can use the __________________ in Tableau to clean / organise your data.

Question77: The View Data window displays as much of the data as possible by default, up to _______________ rows.

Question78: True or False: All rows from both tables are returned in an INNER JOIN

Question79: Which of the following can you add a reference line to?

Question80: Larger image

What is this view referred to as in Tableau?

Question81: When using Animations in a Tableau, which of the following is the default duration for animations?

Question82: Which of the following is the correct way to calculate Profit Ratio in Tableau?

Question83: How can you MANUALLY assign geographic roles to a dimension from the data pane?

Question84: True or False: When relating tables, the fields that define the relationships must have the same data type.

Question85: What does the following icon do in Tableau?
Larger image

Question86: Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us

Question87: ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Question88: True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use data blending instead.

Question89: Is it possible to make a Measure discrete?

Question90: Is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?

Question91: Yes or No: The number of marks will increase when you increase the number of Dimensions in a view

Question92: Using the dataset, create a bar chart showing the average Quantity broken down by Region, and filtered by Country to only show Japan. What was the average Quantity in the State of Tokyo?

Question93: Which of the following is true about 'Incremental refresh' when creating Extracts in Tableau?

Question94: Using the dataset, plot a Map showing all the countries, filtered by Market to only include LATAM. Which country in the LATAM Market has the highest shipping delay (sum of total number of days between the order date and the ship date)?

Question95: When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors.

Question96: Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

Question97: True or False: A sheet cannot be used within a story directly. Either sheets should be used within a dashboard, or a dashboard should be used within a story.

Question98: Which of the following is NOT a new feature introduced in Tableau 2020.1?

Question99: When there are both negative and positive values for a field, the default range of values will use two color ranges. This is known as a ______________ palette.

Question100: If you see a Blue field, generally it will add _____________ to the view

Question101: Which of the following are valid ways to show Mark Labels in the visualisation?

Question102: Which of the following are valid ways of Grouping Data?

Question103: When using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas _____________ is the custom name we created in Tableau.

Question104: _________________ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance.

Question105: Which of the following are True for Measure Names?

Question106: While borders and background colors let you visually highlight items on a dashboard, _________ lets you precisely space items.

Question107: Which of the following calculations DO NOT need a quick table calculation?

Question108: Using the Time Series table, create a cross-tab showing sales for each Assortment broken down by Year and Quarter. In Q4 of October 2017, what was the Average sales amount for the Hardware assortment?

Question109: Which of the following are correct ways to define a join in Tableau version 2020.3 and above?

Question110: A _____________ action is a hyperlink that points to a web page, file, or other web-based resource outside of Tableau.

Question111: Which data type in Tableau does this icon represent?
Larger image

Question112: Download the Dataset from: https://drive.google.com/file/d/12AYHfiPWkwBmvH0zbumOURgUX6Az00Rw/view?usp=sharing Using the Time Series Table, create a line chart to show Sales over time. Which Month and Year witnessed the lowest Sales?

Question113: Using the dataset provided, create a crosstab showing the Profit of each Region per Year, then add grand totals to the view. What was the total Profit for Canada in 2012 and the total Profit for Canada for 2011 through
2014, respectively?

Question114: Which of the following can you add a reference line to?

Question115: Which of the following are valid Dashboard size options?

Question116: What is the following icon in the Data pane used to do?
Larger image

Question117: Larger image

What is this view referred to as in Tableau?

Question118: True or False: We can disaggregate the data, to see all of the marks in the view at the most detailed level of granularity

Question119: How can you format numbers in Tableau as currency?

Question120: ______________ is a method for appending values (rows) to tables. You can use this method if both tables have the same columns. The result is a virtual table that has the same columns but extends vertically by adding rows of data.

Question121: In Tree maps, the size begins with the largest rectangle on the ________________ and the smallest rectangle on the ________________.

Question122: Most viewers scan content starting at the _____________ of a page.

Question123: Creating a scatter plot requires a minimum of how many measures?

Question124: You want to add Custom shapes to your visualisation. Where can you add these new shapes?

Question125: Using the CoffeeChain table, create a crosstab showing the Total Expenses per State and add Column Grand Totals to the view. Now group the states of New York, California and Washington. What percent of the total sales does this group contribute?

Question126: For a relative date filter, the default anchor is _________________

Question127: A ________________ is a single zip file that contains a workbook along with any supporting local file data and background images. This format is the best way to package your work for sharing with others who don't have access to the original data.

Question128: Which of the following are valid ways to make the font more readable in Tableau?

Question129: Which of the following is a valid way to create Sets in Tableau?

Question130: According to Tableau's 'Order of Operations', which of the following filters is applied FIRST?

Question131: How can you format an axis as Bold in Tableau?

Question132: Suppose I have the following view. What will be the total number of marks if I drag a new measure to the row shelf vs the column shelf?

Question133: As a general best practice, how many categories can a pie chart display effectively?